Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'N'.
|
|
The error occurred in C:/Web/PCL_NEW/NQF08/NQF_Narrative-new.cfm: line 73
|
71 : select top 1 isnull(tblmhahospitalnarratives.comments,'') as narrative,tblmhahospitalnarratives.updateddate from
72 : tblmhahospitalnarratives
73 : where fk_hospital_id = #ID# and fk_narrative_id in (#narrativeid#)
74 : </CFQUERY>
75 : <cfif #narrative.recordcount# gt 0>
|
|
SQLSTATE |
42S22 |
DATASOURCE |
MHA |
VENDORERRORCODE |
207 |
SQL |
select top 1 isnull(tblmhahospitalnarratives.comments,'') as narrative,tblmhahospitalnarratives.updateddate from
tblmhahospitalnarratives
where fk_hospital_id = 5 and fk_narrative_id in (N)
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.191.158.202 |
Referrer |
|
Date/Time |
17-May-24 11:46 PM |
|